package com.trkj.dao.jpa;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojos.LmbMaterialStorageDetail;

public interface LmbMaterialStorageDetailDAO extends CrudRepository<LmbMaterialStorageDetail, String> {
	@Query("select max(c.msdId) from LmbMaterialStorageDetail c where c.msdId like ?1%")
    public String findMaxID(String a);
	
	@Query("select msd from LmbMaterialStorageDetail msd where msd.msdMsId = ?1")
	public List<LmbMaterialStorageDetail> queryMatStorDetailsByMsdMsId(String msId);
}
